
INSERT INTO board
( board_id, board_name , board_user_id )
SELECT BOARD_ID_SEQ.NEXTVAL ,
dbms_random.string('A', 5 ) ,
2
FROM DUAL
CONNECT BY LEVEL <= 1000 ;

INSERT INTO paper
( paper_id, paper_board_id, paper_user_id, paper_name , paper_content )
SELECT
PAPER_ID_SEQ.NEXTVAL ,
1,
2,
dbms_random.string('A', 5 ) ,
dbms_random.string('A', 100 )
FROM DUAL
CONNECT BY LEVEL <= 200 ;

INSERT INTO paper
( paper_id, paper_board_id, paper_user_id, paper_name , paper_content )
SELECT
PAPER_ID_SEQ.NEXTVAL ,
4,
2,
dbms_random.string('A', 5 ) ,
dbms_random.string('A', 100 )
FROM DUAL
CONNECT BY LEVEL <= 200 ;

DELETE  FROM log_paper WHERE log_paper_user_id = 1 ;

DELETE FROM paper
WHERE paper_user_id = 1 ;

COMMIT ;

SELECT * FROM board  ORDER BY board_id ;
